
SELECT [VolumeId], [VolumeName], [VolumeYear], [Active], [CreationUserId], [CreationDateTime], [UpdateUserId], [UpdateDateTime] 
FROM [NPC].[dbo].[Volumes]

SELECT [IssueId], [IssueName], [Active], [CreationUserId], [CreationDateTime], [UpdateUserId], [UpdateDateTime] 
FROM [NPC].[dbo].[Issues]

SELECT [VolumeIssueId], [VolumeId], [IssueId] 
FROM [NPC].[dbo].[VolumeIssues]

SELECT [VolumeIssueId], [IssueDocTypeId], [DocId] 
FROM [NPC].[dbo].[IssueDocuments]

SELECT [VolumeIssueId], [ArticleId] 
FROM [NPC].[dbo].[IssueArticles]

SELECT [ArticleId], [Title], [Authors], [Keywords], [Active], [CreationUserId], [CreationDateTime], [UpdateUserId], [UpdateDateTime] 
FROM [NPC].[dbo].[Articles]

SELECT [ArticleId], [ArtDocTypeId], [DocId] 
FROM [NPC].[dbo].[ArticleDocuments]

SELECT [DocId], [Data], [FileName], [FileSizeKB], [Comments], [Active], [CreationUserId], [CreationDateTime], [UpdateUserId], [UpdateDateTime] 
FROM [NPC].[dbo].[Documents]